<?php

use Illuminate\Database\Migrations\Migration;

class CreateProductProTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('Product_pro', function($table)
	    {
	        $table->increments('pro_code');
	        $table->string('pro_name', 30);
	        $table->string('pro_codctrl', 8)->unique();
	        $table->string('pro_description', 200)->nullable();
	        $table->decimal('pro_priceunit', 18, 2);
	        $table->bigInteger('pro_stock');
	        $table->boolean('pro_active');
	        $table->timestamps();
	    });
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('Product_pro');
	}

}